Sometimes you need to find login information. Looking at just the logins on an instance will not allow you to find how a user is connecting. A login maybe nested in an Active Directory group or a login locally to … Continue reading I am Only Here to Help – sys.xp_logininfo and sys.helplogins